Tabela VaccineOrder

Definicja tabeli VaccineOrder

Name

VaccineOrder

Code

VaccineOrder

Comment

Zlecenie szczepienia


Lista kolumn tabeli VaccineOrder

Name

Code

VaccineOrderID

VaccineOrderID

EventID

EventID

VaccineOrderStatusID

VaccineOrderStatusID

PatientID

PatientID

OrderComment

OrderComment

StatusComment

StatusComment

Notification

Notification

PlaningPerson

PlaningPerson

SuggestedPerfDT

SuggestedPerfDT

QualifingPerson

QualifingPerson

QualificationDT

QualificationDT

QualificationComment

QualificationComment

PerfPerson

PerfPerson

PerfDT

PerfDT

PerfComment

PerfComment

InsertingPerson

InsertingPerson

InsertDT

InsertDT

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT


Kolumna VaccineOrderID tabeli VaccineOrder

Definicja kolumny VaccineOrderID tabeli VaccineOrder

Name

VaccineOrderID

Code

VaccineOrderID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID zlecenia


Kolumna EventID tabeli VaccineOrder

Definicja kolumny EventID tabeli VaccineOrder

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VaccineOrderStatusID tabeli VaccineOrder

Definicja kolumny VaccineOrderStatusID tabeli VaccineOrder

Name

VaccineOrderStatusID

Code

VaccineOrderStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatientID tabeli VaccineOrder

Definicja kolumny PatientID tabeli VaccineOrder

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OrderComment tabeli VaccineOrder

Definicja kolumny OrderComment tabeli VaccineOrder

Name

OrderComment

Code

OrderComment

Data Type

VARCHAR2(255)

Mandatory

No

Comment

komentarz do zlecenia


Kolumna StatusComment tabeli VaccineOrder

Definicja kolumny StatusComment tabeli VaccineOrder

Name

StatusComment

Code

StatusComment

Data Type

VARCHAR2(512)

Mandatory

No

Comment

komentarz do statusu


Kolumna Notification tabeli VaccineOrder

Definicja kolumny Notification tabeli VaccineOrder

Name

Notification

Code

Notification

Data Type

NUMBER(1)

Mandatory

Yes

Comment

informacja czy wyslano powiadomienie


Kolumna PlaningPerson tabeli VaccineOrder

Definicja kolumny PlaningPerson tabeli VaccineOrder

Name

PlaningPerson

Code

PlaningPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SuggestedPerfDT tabeli VaccineOrder

Definicja kolumny SuggestedPerfDT tabeli VaccineOrder

Name

SuggestedPerfDT

Code

SuggestedPerfDT

Data Type

DATE

Mandatory

No

Comment

planowana data


Kolumna QualifingPerson tabeli VaccineOrder

Definicja kolumny QualifingPerson tabeli VaccineOrder

Name

QualifingPerson

Code

QualifingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna QualificationDT tabeli VaccineOrder

Definicja kolumny QualificationDT tabeli VaccineOrder

Name

QualificationDT

Code

QualificationDT

Data Type

DATE

Mandatory

No

Comment

data kwalifikacji


Kolumna QualificationComment tabeli VaccineOrder

Definicja kolumny QualificationComment tabeli VaccineOrder

Name

QualificationComment

Code

QualificationComment

Data Type

VARCHAR2(512)

Mandatory

No

Comment

komentarz kwalifikacji


Kolumna PerfPerson tabeli VaccineOrder

Definicja kolumny PerfPerson tabeli VaccineOrder

Name

PerfPerson

Code

PerfPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfDT tabeli VaccineOrder

Definicja kolumny PerfDT tabeli VaccineOrder

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

data wykonania


Kolumna PerfComment tabeli VaccineOrder

Definicja kolumny PerfComment tabeli VaccineOrder

Name

PerfComment

Code

PerfComment

Data Type

VARCHAR2(255)

Mandatory

No

Comment

komentarz do wykonania


Kolumna InsertingPerson tabeli VaccineOrder

Definicja kolumny InsertingPerson tabeli VaccineOrder

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertDT tabeli VaccineOrder

Definicja kolumny InsertDT tabeli VaccineOrder

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna LastModifiedPerson tabeli VaccineOrder

Definicja kolumny LastModifiedPerson tabeli VaccineOrder

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli VaccineOrder

Definicja kolumny LastModifiedDT tabeli VaccineOrder

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli VaccineOrder

Name

Code

Primary

PK_VaccineOrder

PK_VaccineOrder

X


Klucz PK_VaccineOrder tabeli VaccineOrder

Definicja klucza PK_VaccineOrder tabeli VaccineOrder

Name

PK_VaccineOrder

Code

PK_VaccineOrder

Primary

Yes

Comment